# -*- codeing = utf-8 -*-
# @Time: 2021/12/18 1:59
# @Author: Foxhuty
# @File: HSC_zipfile.py
# @Software: PyCharm
# @Based on python 3.9

import zipfile
import pandas as pd


# zp = zipfile.ZipFile(r'D:\成绩统计结果\成绩统计结果.zip', 'w')
#
# zp.write(r'D:\成绩统计结果\监考安排信息表.xlsx')
#
# zp.close()
filepath = r'D:\work documents\高2021级\高一监考数据.xlsx'
df = pd.read_excel(filepath, index_col='id', sheet_name='teacher_names', dtype={'id': str})

def file_zipping(file_name):
    with zipfile.ZipFile(r'D:\成绩统计结果\成绩统计.zip', 'w') as zp:
        zp.write(file_name)
    return f'successfully done'


# file_zipped = file_zipping(r'D:\成绩统计结果\文理科考室学生名单.xlsx')
# print(file_zipped)

# care = ['h', 'i', 'j']
# no_care = ['a', 'b', 'c', 'd', 'e', 'f', 'g']
#
# for i in range(len(care)):
#     care[i], no_care[i] = no_care[i], care[i]
#
# print(care)
# print(no_care)
# dic={}
# dic=dic.fromkeys(care)
#
# print(dic)
df_list=df['name'].values.tolist()
print(type(df_list))

c=float('4')
print(c)